package com.qfedu.tantu.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qfedu.tantu.entity.Housinfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description:
 * @Author: 赵金帅
 * @Date: 2022/07/03/20:16
 */
public interface HousInfoDao extends BaseMapper<Housinfo> {
    @Select("SELECT id,housname,info,imgurl FROM t_housinfo where housname=#{housname}};")
    List<Housinfo> selectAllBy(String housname);

    @Select("SELECT id,housname,info,imgurl FROM t_housinfo where location=#{location}};")
    List<Housinfo> selectAllByLocation(String location);
}